package com.zhumo.sz.entity.bus;


import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.zhumo.sz.common.annotation.TransientSink;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiModel;
import io.swagger.models.auth.In;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.apache.kafka.common.protocol.types.Field;

import java.math.BigDecimal;
import java.sql.Time;
import java.sql.Timestamp;

/**
 * 公交线路信息
 * id INT 主键id PRIMARY KEY
 * line_code INT 公交线路唯一标识 PRIMARY KEY
 * line_name INT 公交线路名称
 * start_site_code BIGINT 起始站点编码
 * terminal_site_code BIGINT 终点站编码
 * operator_com_id VARCHAR 营运公司编码
 * upstream_route_station TEXT 上行途径站点 FOREIGH KEY
 * downward_route_station TEXT 下行途径站点 FOREIGH KEY
 * earliest_departure_time VARCHAR 首班车时间
 * last_departure_time VARCHAR 末班车时间
 * classes VARCHAR 班次间隔
 * unit_price DECIMAL 单价
 * line_price DECIMAL 全线价格
 * is_enabled TINYINT 是否有效
 * open_time DATETIME 通车时间
 * create_time TIMESTAMP 创建时间
 * update_time TIMESTAMP 更新时间
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@ApiModel(value = "公交线路信息",description = "公交线路信息表")
public class BusLineInfo {

    private Integer id;
    private String lineCode;
    private String lineName;
    private String startSiteName; //暂时用名称充当外键
    private String terminalSiteName;
    private Integer operatorComId; //公司id
    private String upstreamRouteStation;
    private String downwardRouteStation;
    private String earliestDepartureTime;
    private String lastDepartureTime;
    private String classes;
    private BigDecimal unitPrice;
    private BigDecimal linePrice;
    private boolean isEnabled;
    private String openTime;
    private String version;
    @TransientSink
    private Timestamp createTime;
    @TransientSink
    private Timestamp updateTime;
}
